IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_SiteAdminMapSave]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[cms_sp_SiteAdminMapSave]
GO
CREATE procedure [dbo].[cms_sp_SiteAdminMapSave]
(
@Id [int],
@ParentNodeId [int] = null,
@NodeTitle nvarchar(150),
@NodeDescription nvarchar(500) = null,
@NodeUrl nvarchar(250),
@IsSpecial bit,
@IsVisible bit,
@IsCustom bit
)
as
update [dbo].[SiteAdminMaps]
set [NodeTitle] = @NodeTitle,
	[NodeDescription] = @NodeDescription,
	[NodeUrl] = @NodeUrl,
	[IsSpecial] = @IsSpecial,
	[IsVisible] = @IsVisible,
	[IsCustom] = @IsCustom
where [SiteAdminMapId] = @Id


GO

